projects / namibia / blobdiff
? search:
summary | shortlog | log | commit | commitdiff | tree
raw | inline | side by side
latest update
[namibia] / data / old_b4c stuff / update_auction_newsletter_template.sql
diff --git a/data/old_b4c stuff/update_auction_newsletter_template.sql b/data/old_b4c stuff/update_auction_newsletter_template.sql
index b7eba2b..821c6df 100644 (file)
--- a/data/old_b4c stuff/update_auction_newsletter_template.sql
+++ b/data/old_b4c stuff/update_auction_newsletter_template.sql
@@ -1,3 +1,3 @@
-UPDATE `mig_db`.`lib_template` SET `email_template`='<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\"\r     \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r <html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\">\r <head>\r        <meta http-equiv=\"Content-type\" content=\"text/html; charset=utf-8\" />\r     <title></title>\r </head>\r <body style=\"padding:0;margin:0;\">\r      <!-- Begin 100% Wrapping Table -->\r    <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\" align=\"center\" style=\"margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;\">\r                 <tr>\r                  <td style=\"padding:20px 0;\">\r                                <!-- Begin Main Template Table -->\r                            <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"800\" align=\"center\" style=\"border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;\">\r                                      <tr>\r                                          <td colspan=\"7\">\r                                                    <img src=\"{APP_HOST}/images/EmailHeader.png\" width=\"800\" height=\"100\" alt=\"Please set images to always display for our emails\" style=\"display:block;\" />\r                                            </td>\r                                         </tr>\r                                         <tr>\r                                          <td colspan=\"7\" align=\"right\" style=\"margin:0;padding:10px;font-weight:bold;color:#FFFFFF;background:#AA0000;\">\r                                                         Auction vehicles that will end today: [auctioncount]\r                                          </td>\r                                         </tr>\r                                         <tr>\r                                          <td align=\"center\" style=\"margin:0;padding:10px;color:#FFFFFF;background:#333333;font-weight:bold;\">\r                                                      Model\r                                                 </td>\r                                                 <td align=\"center\" style=\"margin:0;padding:10px;color:#FFFFFF;background:#333333;font-weight:bold;\">\r                                                      Type\r                                          </td>\r                                                 <td align=\"center\" style=\"margin:0;padding:10px;color:#FFFFFF;background:#333333;font-weight:bold;\">\r                                                      M&M code\r                                              </td>\r                                                 <td align=\"center\" style=\"margin:0;padding:10px;color:#FFFFFF;background:#333333;font-weight:bold;\">\r                                                      Year\r                                          </td>\r                                                 <td align=\"center\" style=\"margin:0;padding:10px;color:#FFFFFF;background:#333333;font-weight:bold;\">\r                                                      KM\r                                            </td>\r                                                 <td align=\"center\" style=\"margin:0;padding:10px;color:#FFFFFF;background:#333333;font-weight:bold;\">\r                                                      Location\r                                              </td>\r                                                 <td align=\"center\" style=\"margin:0;padding:10px;color:#FFFFFF;background:#333333;font-weight:bold;\">\r                                                      Reserve\r                                               </td>\r                                         </tr>\r                                         [repeater]\r                                    <tr>\r                                          <td colspan=\"7\" style=\"background:#ececec;padding:10px 0 0;\">\r                                                     <!-- Begin Footer table -->\r                                                   <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"800\" style=\"border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;\">\r                                                                <tr>\r                                                                  <!-- Spacing Column -->\r                                                                       <td width=\"20\" valign=\"top\" style=\"width:20px;\">&nbsp;</td>\r                                                                     <!-- Main Column -->\r                                                                  <td width=\"380\" valign=\"top\" style=\"width:380px; font-family: Arial, Sans-serif; font-size:12px;\">\r                                                                              <p style=\"margin:0 0 1em;padding:0;\"><b>bid4cars.co.za</b></p>\r                                                                      </td>\r                                                                         <!-- Spacing Column -->\r                                                                       <td width=\"380\" valign=\"top\" align=\"right\" style=\"width:380px;\">\r                                                                              Click <a href=\"{APP_HOST}/unsubscribe/newsletter\">here</a> to unsubscribe from newsletters.\r                                                                         </td>\r                                                                         <!-- Spacing Column -->\r                                                                       <td width=\"20\" valign=\"top\" style=\"width:20px;\">&nbsp;</td>\r                                                             </tr>\r                                                         </table>\r                                                      <!-- /End Footer Table -->\r                                            </td>\r                                         </tr>\r                                 </table>\r                              <!-- /End Main Template Table -->\r                     </td>\r                 </tr>\r         </table>\r <!-- /End 100% Wrapping Table  -->\r </body>\r </html>\r ' WHERE `id`='1';
+UPDATE `mig_db`.`lib_template` SET `email_template`='<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\"\r     \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r <html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\">\r <head>\r        <meta http-equiv=\"Content-type\" content=\"text/html; charset=utf-8\" />\r     <title></title>\r </head>\r <body style=\"padding:0;margin:0;\">\r      <!-- Begin 100% Wrapping Table -->\r    <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\" align=\"center\" style=\"margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;\">\r                 <tr>\r                  <td style=\"padding:20px 0;\">\r                                <!-- Begin Main Template Table -->\r                            <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"800\" align=\"center\" style=\"border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;\">\r                                      <tr>\r                                          <td colspan=\"7\">\r                                                    <img src=\"{APP_HOST}/images/EmailHeader.png\" width=\"800\" height=\"100\" alt=\"Please set images to always display for our emails\" style=\"display:block;\" />\r                                            </td>\r                                         </tr>\r                                         <tr>\r                                          <td colspan=\"7\" align=\"right\" style=\"margin:0;padding:10px;font-weight:bold;color:#FFFFFF;background:#AA0000;\">\r                                                         Auction vehicles that will end today: [auctioncount]\r                                          </td>\r                                         </tr>\r                                         <tr>\r                                          <td align=\"center\" style=\"margin:0;padding:10px;color:#FFFFFF;background:#333333;font-weight:bold;\">\r                                                      Model\r                                                 </td>\r                                                 <td align=\"center\" style=\"margin:0;padding:10px;color:#FFFFFF;background:#333333;font-weight:bold;\">\r                                                      Type\r                                          </td>\r                                                 <td align=\"center\" style=\"margin:0;padding:10px;color:#FFFFFF;background:#333333;font-weight:bold;\">\r                                                      M&M code\r                                              </td>\r                                                 <td align=\"center\" style=\"margin:0;padding:10px;color:#FFFFFF;background:#333333;font-weight:bold;\">\r                                                      Year\r                                          </td>\r                                                 <td align=\"center\" style=\"margin:0;padding:10px;color:#FFFFFF;background:#333333;font-weight:bold;\">\r                                                      KM\r                                            </td>\r                                                 <td align=\"center\" style=\"margin:0;padding:10px;color:#FFFFFF;background:#333333;font-weight:bold;\">\r                                                      Location\r                                              </td>\r                                                 <td align=\"center\" style=\"margin:0;padding:10px;color:#FFFFFF;background:#333333;font-weight:bold;\">\r                                                      Reserve\r                                               </td>\r                                         </tr>\r                                         [repeater]\r                                    <tr>\r                                          <td colspan=\"7\" style=\"background:#ececec;padding:10px 0 0;\">\r                                                     <!-- Begin Footer table -->\r                                                   <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"800\" style=\"border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;\">\r                                                                <tr>\r                                                                  <!-- Spacing Column -->\r                                                                       <td width=\"20\" valign=\"top\" style=\"width:20px;\">&nbsp;</td>\r                                                                     <!-- Main Column -->\r                                                                  <td width=\"380\" valign=\"top\" style=\"width:380px; font-family: Arial, Sans-serif; font-size:12px;\">\r                                                                              <p style=\"margin:0 0 1em;padding:0;\"><b>bid4cars.com.na</b></p>\r                                                                     </td>\r                                                                         <!-- Spacing Column -->\r                                                                       <td width=\"380\" valign=\"top\" align=\"right\" style=\"width:380px;\">\r                                                                              Click <a href=\"{APP_HOST}/unsubscribe/newsletter\">here</a> to unsubscribe from newsletters.\r                                                                         </td>\r                                                                         <!-- Spacing Column -->\r                                                                       <td width=\"20\" valign=\"top\" style=\"width:20px;\">&nbsp;</td>\r                                                             </tr>\r                                                         </table>\r                                                      <!-- /End Footer Table -->\r                                            </td>\r                                         </tr>\r                                 </table>\r                              <!-- /End Main Template Table -->\r                     </td>\r                 </tr>\r         </table>\r <!-- /End 100% Wrapping Table  -->\r </body>\r </html>\r ' WHERE `id`='1';
 
 UPDATE `mig_db`.`lib_template` SET `tags`='auctioncount' WHERE `id`='1';
\ No newline at end of file
Unnamed repository; edit this file 'description' to name the repository.